Hi There,

Is there any how to make a short version of the following:

On this case I have only 4, But I need to make it for 23.

=CONCATENATE(IF(B7=401,"LILIK",""),IF(B7=402,"BRATA",""),IF(B7=403,"IRWAN",""),IF(B7=404,"HARI",""))Thank

Thank you so much for the help!

Why concatenate? B7 can have only one value at a time, so at most one of the IFs will return a non-empty string.

You could use

=CHOOSE(B7-400,"LILIK","BRATA",'IRWAN","HARI",...)

Or create a table with 400, 401, 402, ... in the first column and LILIK, BRATA, IRWAN, ... in the second column. Say in K1:L23.

Then use VLOOKUP:

=VLOOKUP(B7,K1:L23,2,FALSE)

Greetings,
Mr. Hans. Thank you so much for your prompt response.<o:p></o:p>

But, as you can see bellow, I need something that allows me to type the
(401,402,403,404....) on "A,C, E, G." and showing the respective
result on BDF...H)

=CONCATENATE(IF(B6=401,"LILIK",""),IF(B6=402,"BRATA",""),IF(B6=403,"IRWAN",""),IF(B6=404,"HARI",""))

	DAY1	STW	DAY2	STW	DAY3	STW	DAY4	STW
101
102
103
104					403	IRWAN
105	403	IRWAN					401	LILIK
106
107	401	LILIK			401	LILIK
108	108

In the other hand, What I really need it is to be able to type the information as per
below, and automatically the information above will be inserted.

I know I need a "table" with those Table numbers (52,71,73....) Assigned to
the, (401,402,403...)... so when we insert the information on the IMAGE
2, will pop up on IMAGE 1.

ROOM	TIME	PAX	TABLE	WAITER
318	7:00 PM	2	1	404
148	7:00 PM	2	5	402
332	7:00 PM	2	4	402
315	7:00 PM	2	71	403
329	7:00 PM	2	72	403

I've been trying for quite a few days already but my knowledge is limited.

If you are able to support me on this one, your help will be gratefully appreciated.

Thank you so much, in advance.

• Edited by Gutoazuk 22 hours 59 minutes ago

Create a list of the numbers and corresponding names on a separate worksheet in the same workbook.

With the list selected, enter a name such as Waiters in the name box on the left hand side of the formula bar.

In the screenshot below, I have used A1:B5, but the list can be as long as you want.

On the worksheet shown in your first image, it looks like the numbers 401 etc. are in column B, D, F etc., starting in B2.

Enter the following formula in C2:

=IFERROR(VLOOKUP(B2,Waiters,2,FALSE),"")

Fill down from B2 as far as needed, say to B100.

Now, with B2:B100 still selected, click the Copy button on the ribbon or press Ctrl+C.

Select cell D2 and paste - click the Paste button or press Ctrl+V.

Repeat for F2, H2 etc.

Greetings,
Mr. Hans. Thank you so much for your prompt response.<o:p></o:p>

But, as you can see bellow, I need something that allows me to type the
(401,402,403,404....) on "A,C, E, G." and showing the respective
result on BDF...H)

=CONCATENATE(IF(B6=401,"LILIK",""),IF(B6=402,"BRATA",""),IF(B6=403,"IRWAN",""),IF(B6=404,"HARI",""))

	DAY1	STW	DAY2	STW	DAY3	STW	DAY4	STW
101
102
103
104					403	IRWAN
105	403	IRWAN					401	LILIK
106
107	401	LILIK			401	LILIK
108	108

In the other hand, What I really need it is to be able to type the information as per
below, and automatically the information above will be inserted.

I know I need a "table" with those Table numbers (52,71,73....) Assigned to
the, (401,402,403...)... so when we insert the information on the IMAGE
2, will pop up on IMAGE 1.

ROOM	TIME	PAX	TABLE	WAITER
318	7:00 PM	2	1	404
148	7:00 PM	2	5	402
332	7:00 PM	2	4	402
315	7:00 PM	2	71	403
329	7:00 PM	2	72	403

I've been trying for quite a few days already but my knowledge is limited.

If you are able to support me on this one, your help will be gratefully appreciated.

Thank you so much, in advance.

• Edited by Gutoazuk Saturday, July 04, 2015 8:29 AM

Im Getting there with your assistance.

Thank you so very much!!!!

I will have more.. if you don't mind.. soon. = )

Thanks again.!